package com.example.micro.es.api.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Update;

/**
 * @author Code Farmer
 * @create 2020/11/12 2:49 下午
 */
@Mapper
public interface TestUpdateExpandMapper {

    @Update({
            "update test_update set status = '1' " +
            "where status='0' " +
                    "and idx1 is null " +
                    "and idx2 =  #{idx2,jdbcType=VARCHAR} limit 1"})
    int updateStatus(String idx2);

}
